Desktop Computer Skills
Microsoft Office 2016: Beginning Excel
Microsoft Excel 2016 Essentials: Charts, Tables, and Images
mo_beel_a05_dt_enus
Microsoft Excel 2016 Essentials: Creating, Editing, and Saving Workbooks
mo_beel_a01_dt_enus
Microsoft Excel 2016 Essentials: Data Presentation Strategies
mo_beel_a03_dt_enus
Microsoft Excel 2016 Essentials: Formatting Data
mo_beel_a02_dt_enus
Microsoft Excel 2016 Essentials: Formulas and Functions
mo_beel_a04_dt_enus
Microsoft Excel 2016 Essentials: Charts, Tables, and Images
Lesson Objectives
Microsoft Excel 2016 Essentials: Charts, Tables, and Images
- start the course
- create a table in Microsoft Excel 2016
- modify an existing table in Microsoft Excel 2016
- create a chart in Microsoft Excel 2016
- modify an existing chart in Microsoft Excel 2016
- style a chart with a quick style in Microsoft Excel 2016
- add images to a worksheet in Microsoft Excel 2016
- add screenshot and screen clippings to a worksheet in Microsoft Excel 2016
- modify an image using Microsoft Excel 2016 tools
- add headers and footers to a Microsoft Excel 2016 workbook
- add tables and charts to a worksheet in Microsoft Excel 2016
- add images, headers, and footers in Microsoft Excel 2016
Overview/Description
Using tables, charts, and images in Excel 2016, you can create attractive and well-organized representations of worksheet and workbook data. These elements can be easily inserted into your workbook and customized as necessary. In this course, you will learn how to effectively use and customize tables and charts in Excel 2016. You will also learn how to use headers and footers to add additional information to your work.
Using tables, charts, and images in Excel 2016, you can create attractive and well-organized representations of worksheet and workbook data. These elements can be easily inserted into your workbook and customized as necessary. In this course, you will learn how to effectively use and customize tables and charts in Excel 2016. You will also learn how to use headers and footers to add additional information to your work.
Target Audience
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification
Microsoft Excel 2016 Essentials: Charts, Tables, and Images
Lesson Objectives
Microsoft Excel 2016 Essentials: Charts, Tables, and Images
- start the course
- create a table in Microsoft Excel 2016
- modify an existing table in Microsoft Excel 2016
- create a chart in Microsoft Excel 2016
- modify an existing chart in Microsoft Excel 2016
- style a chart with a quick style in Microsoft Excel 2016
- add images to a worksheet in Microsoft Excel 2016
- add screenshot and screen clippings to a worksheet in Microsoft Excel 2016
- modify an image using Microsoft Excel 2016 tools
- add headers and footers to a Microsoft Excel 2016 workbook
- add tables and charts to a worksheet in Microsoft Excel 2016
- add images, headers, and footers in Microsoft Excel 2016
Overview/Description
Using tables, charts, and images in Excel 2016, you can create attractive and well-organized representations of worksheet and workbook data. These elements can be easily inserted into your workbook and customized as necessary. In this course, you will learn how to effectively use and customize tables and charts in Excel 2016. You will also learn how to use headers and footers to add additional information to your work.
Using tables, charts, and images in Excel 2016, you can create attractive and well-organized representations of worksheet and workbook data. These elements can be easily inserted into your workbook and customized as necessary. In this course, you will learn how to effectively use and customize tables and charts in Excel 2016. You will also learn how to use headers and footers to add additional information to your work.
Target Audience
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification
Microsoft Excel 2016 Essentials: Creating, Editing, and Saving Workbooks
Lesson Objectives
Microsoft Excel 2016 Essentials: Creating, Editing, and Saving Workbooks
- start the course
- create Microsoft Excel 2016 workbooks and open existing documents
- recognize the different parts of the Microsoft Excel 2016 interface
- add data to a Microsoft Excel 2016 worksheet
- cut, copy, and paste data in Microsoft Excel 2016
- delete or hide cell, row, and column data in Microsoft Excel 2016
- create and customize worksheets in Microsoft Excel 2016
- add properties information to a Microsoft Excel 2016 document
- save a workbook in Microsoft Excel 2016
- save a workbook to an online location in Microsoft Excel 2016
- configure Excel 2016 worksheets and workbooks for printing
- export Excel 2016 document data in different formats
- create an Excel 2016 document, add data to it, enter property information, and save it
Overview/Description
Microsoft Excel 2016 makes it easy to create worksheets and workbooks, and to manage and manipulate data. In this course, you will learn how to cut, copy, and paste data; navigate between data cells and worksheets; and customize your Excel workspace. You will also learn about creating and opening workbooks, moving data around in Excel 2016, organizing worksheets, and saving and exporting data.
Microsoft Excel 2016 makes it easy to create worksheets and workbooks, and to manage and manipulate data. In this course, you will learn how to cut, copy, and paste data; navigate between data cells and worksheets; and customize your Excel workspace. You will also learn about creating and opening workbooks, moving data around in Excel 2016, organizing worksheets, and saving and exporting data.
Target Audience
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification
Microsoft Excel 2016 Essentials: Creating, Editing, and Saving Workbooks
Lesson Objectives
Microsoft Excel 2016 Essentials: Creating, Editing, and Saving Workbooks
- start the course
- create Microsoft Excel 2016 workbooks and open existing documents
- recognize the different parts of the Microsoft Excel 2016 interface
- add data to a Microsoft Excel 2016 worksheet
- cut, copy, and paste data in Microsoft Excel 2016
- delete or hide cell, row, and column data in Microsoft Excel 2016
- create and customize worksheets in Microsoft Excel 2016
- add properties information to a Microsoft Excel 2016 document
- save a workbook in Microsoft Excel 2016
- save a workbook to an online location in Microsoft Excel 2016
- configure Excel 2016 worksheets and workbooks for printing
- export Excel 2016 document data in different formats
- create an Excel 2016 document, add data to it, enter property information, and save it
Overview/Description
Microsoft Excel 2016 makes it easy to create worksheets and workbooks, and to manage and manipulate data. In this course, you will learn how to cut, copy, and paste data; navigate between data cells and worksheets; and customize your Excel workspace. You will also learn about creating and opening workbooks, moving data around in Excel 2016, organizing worksheets, and saving and exporting data.
Microsoft Excel 2016 makes it easy to create worksheets and workbooks, and to manage and manipulate data. In this course, you will learn how to cut, copy, and paste data; navigate between data cells and worksheets; and customize your Excel workspace. You will also learn about creating and opening workbooks, moving data around in Excel 2016, organizing worksheets, and saving and exporting data.
Target Audience
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification
Microsoft Excel 2016 Essentials: Data Presentation Strategies
Lesson Objectives
Microsoft Excel 2016 Essentials: Data Presentation Strategies
- start the course
- copy data using Auto Fill in Microsoft Excel 2016
- fill a series using Auto Fill in Microsoft Excel 2016
- complete data lists using Flash Fill in Microsoft Excel 2016
- create a hyperlink in an Excel 2016 workbook
- modify an existing hyperlink in an Excel 2016 workbook
- apply conditional formatting using Quick Analysis in Microsoft Excel 2016
- create custom conditional formatting rules in Microsoft Excel 2016
- create and edit basic sparklines in Microsoft Excel 2016
- create custom sparklines in Microsoft Excel 2016
- use hyperlinks, conditional formatting, and sparklines to customize the look of your data in Microsoft Excel 2016
Overview/Description
Microsoft Excel 2016 gives you many options for improving the presentation of your data. In this course, you will learn about adding visual impact to your data using Sparklines, linking to different locations using hyperlinks, and creating custom formatting rules. You will learn about the many tools Excel 2016 provides for visually enhancing the appearance of your data.
Microsoft Excel 2016 gives you many options for improving the presentation of your data. In this course, you will learn about adding visual impact to your data using Sparklines, linking to different locations using hyperlinks, and creating custom formatting rules. You will learn about the many tools Excel 2016 provides for visually enhancing the appearance of your data.
Target Audience
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification
Microsoft Excel 2016 Essentials: Data Presentation Strategies
Lesson Objectives
Microsoft Excel 2016 Essentials: Data Presentation Strategies
- start the course
- copy data using Auto Fill in Microsoft Excel 2016
- fill a series using Auto Fill in Microsoft Excel 2016
- complete data lists using Flash Fill in Microsoft Excel 2016
- create a hyperlink in an Excel 2016 workbook
- modify an existing hyperlink in an Excel 2016 workbook
- apply conditional formatting using Quick Analysis in Microsoft Excel 2016
- create custom conditional formatting rules in Microsoft Excel 2016
- create and edit basic sparklines in Microsoft Excel 2016
- create custom sparklines in Microsoft Excel 2016
- use hyperlinks, conditional formatting, and sparklines to customize the look of your data in Microsoft Excel 2016
Overview/Description
Microsoft Excel 2016 gives you many options for improving the presentation of your data. In this course, you will learn about adding visual impact to your data using Sparklines, linking to different locations using hyperlinks, and creating custom formatting rules. You will learn about the many tools Excel 2016 provides for visually enhancing the appearance of your data.
Microsoft Excel 2016 gives you many options for improving the presentation of your data. In this course, you will learn about adding visual impact to your data using Sparklines, linking to different locations using hyperlinks, and creating custom formatting rules. You will learn about the many tools Excel 2016 provides for visually enhancing the appearance of your data.
Target Audience
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification
Microsoft Excel 2016 Essentials: Formatting Data
Lesson Objectives
Microsoft Excel 2016 Essentials: Formatting Data
- start the course
- apply formatting to different types of numerical data in Microsoft Excel 2016
- format text data in Microsoft Excel 2016
- create custom text and numerical formats in Microsoft Excel 2016
- apply borders and fills to cells in Microsoft Excel 2016
- apply cell styles to your data in Microsoft Excel 2016
- create a custom cell style in Microsoft Excel 2016
- use the Format Painter tool to copy formatting in Microsoft Excel 2016
- insert and resize columns and rows in Microsoft Excel 2016
- alter the alignment, indentation, and orientation of cell data in Microsoft Excel 2016
- merge and split cell data in Microsoft Excel 2016
- apply a cell style, format numbers and text, and modify the positioning of data in Microsoft Excel 2016
Overview/Description
Making your data look good is easy in Microsoft Excel 2016. You can format numbers and text, and apply styles to make your data stand out. In this course, you will learn how to create custom formatting and styles, and copy formatting from cell to cell. In addition to formatting and styling data in Excel 2016, you will learn how to position the data in your spreadsheet.
Making your data look good is easy in Microsoft Excel 2016. You can format numbers and text, and apply styles to make your data stand out. In this course, you will learn how to create custom formatting and styles, and copy formatting from cell to cell. In addition to formatting and styling data in Excel 2016, you will learn how to position the data in your spreadsheet.
Target Audience
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification
Microsoft Excel 2016 Essentials: Formatting Data
Lesson Objectives
Microsoft Excel 2016 Essentials: Formatting Data
- start the course
- apply formatting to different types of numerical data in Microsoft Excel 2016
- format text data in Microsoft Excel 2016
- create custom text and numerical formats in Microsoft Excel 2016
- apply borders and fills to cells in Microsoft Excel 2016
- apply cell styles to your data in Microsoft Excel 2016
- create a custom cell style in Microsoft Excel 2016
- use the Format Painter tool to copy formatting in Microsoft Excel 2016
- insert and resize columns and rows in Microsoft Excel 2016
- alter the alignment, indentation, and orientation of cell data in Microsoft Excel 2016
- merge and split cell data in Microsoft Excel 2016
- apply a cell style, format numbers and text, and modify the positioning of data in Microsoft Excel 2016
Overview/Description
Making your data look good is easy in Microsoft Excel 2016. You can format numbers and text, and apply styles to make your data stand out. In this course, you will learn how to create custom formatting and styles, and copy formatting from cell to cell. In addition to formatting and styling data in Excel 2016, you will learn how to position the data in your spreadsheet.
Making your data look good is easy in Microsoft Excel 2016. You can format numbers and text, and apply styles to make your data stand out. In this course, you will learn how to create custom formatting and styles, and copy formatting from cell to cell. In addition to formatting and styling data in Excel 2016, you will learn how to position the data in your spreadsheet.
Target Audience
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification
Microsoft Excel 2016 Essentials: Formulas and Functions
Lesson Objectives
Microsoft Excel 2016 Essentials: Formulas and Functions
- start the course
- create basic formulas in Microsoft Excel 2016
- recognize Microsoft Excel 2016 formula operators
- recognize the order of operations in Microsoft Excel 2016
- create named cell ranges in Microsoft Excel 2016
- use named cell ranges in formulas in Microsoft Excel 2016
- use the SUM function to calculate totals in Microsoft Excel 2016
- calculate the AVERAGE, COUNT, MIN, and MAX of a column or row of numbers in Microsoft Excel 2016
- use the AND, OR, and NOT functions in Microsoft Excel 2016
- apply conditional logic using the IF function in Microsoft Excel 2016
- handle errors using IFERROR in Microsoft Excel 2016
- create a formula and named cell range and use functions to perform calculations in Microsoft Excel 2016
Overview/Description
Microsoft Excel 2016 allows you to perform complex calculations on your workbook data. Being able to use formulas to complete calculations not only simplifies your work but also helps to reduce the number of errors that can arise in such complex tasks. In this course, you will learn about the basic concepts and terminology associated with formulas and functions. You will learn about the various ways of referring to cells and cell ranges, and how to use basic functions including logical and IF-type functions.
Microsoft Excel 2016 allows you to perform complex calculations on your workbook data. Being able to use formulas to complete calculations not only simplifies your work but also helps to reduce the number of errors that can arise in such complex tasks. In this course, you will learn about the basic concepts and terminology associated with formulas and functions. You will learn about the various ways of referring to cells and cell ranges, and how to use basic functions including logical and IF-type functions.
Target Audience
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification
Microsoft Excel 2016 Essentials: Formulas and Functions
Lesson Objectives
Microsoft Excel 2016 Essentials: Formulas and Functions
- start the course
- create basic formulas in Microsoft Excel 2016
- recognize Microsoft Excel 2016 formula operators
- recognize the order of operations in Microsoft Excel 2016
- create named cell ranges in Microsoft Excel 2016
- use named cell ranges in formulas in Microsoft Excel 2016
- use the SUM function to calculate totals in Microsoft Excel 2016
- calculate the AVERAGE, COUNT, MIN, and MAX of a column or row of numbers in Microsoft Excel 2016
- use the AND, OR, and NOT functions in Microsoft Excel 2016
- apply conditional logic using the IF function in Microsoft Excel 2016
- handle errors using IFERROR in Microsoft Excel 2016
- create a formula and named cell range and use functions to perform calculations in Microsoft Excel 2016
Overview/Description
Microsoft Excel 2016 allows you to perform complex calculations on your workbook data. Being able to use formulas to complete calculations not only simplifies your work but also helps to reduce the number of errors that can arise in such complex tasks. In this course, you will learn about the basic concepts and terminology associated with formulas and functions. You will learn about the various ways of referring to cells and cell ranges, and how to use basic functions including logical and IF-type functions.
Microsoft Excel 2016 allows you to perform complex calculations on your workbook data. Being able to use formulas to complete calculations not only simplifies your work but also helps to reduce the number of errors that can arise in such complex tasks. In this course, you will learn about the basic concepts and terminology associated with formulas and functions. You will learn about the various ways of referring to cells and cell ranges, and how to use basic functions including logical and IF-type functions.
Target Audience
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification
